www.gusucode.com > 帝国网站管理系统(帝国CMS) 6 > 帝国网站管理系统(帝国CMS) 6.5繁体UTF-8/upload/e/data/html/list/alllistinfo.php
<?php if(!defined('InEmpireCMS')) { exit(); } ?> <?php //查詢SQL,如果要顯示自定義字段記得在SQL裡增加查詢字段 $query="select id,classid,titleurl,groupid,newspath,filename,checked,isqf,havehtml,istop,isgood,firsttitle,ismember,userid,username,plnum,totaldown,onclick,newstime,truetime,lastdotime,titlepic,title from {$dbtbpre}ecms_".$tbname.$where." order by ".$doorder." limit $offset,$line"; $sql=$empire->query($query); ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <link rel="stylesheet" href="adminstyle/<?=$loginadminstyleid?>/adminstyle.css" type="text/css"> <title>管理信息</title> <script> function CheckAll(form) { for (var i=0;i<form.elements.length;i++) { var e = form.elements[i]; if (e.name != 'chkall') e.checked = form.chkall.checked; } } function GetSelectId(form) { var ids=''; var dh=''; for (var i=0;i<form.elements.length;i++) { var e = form.elements[i]; if (e.name == 'id[]') { if(e.checked==true) { ids+=dh+e.value; dh=','; } } } return ids; } function PushInfoToSp(form) { var id=''; id=GetSelectId(form); if(id=='') { alert('請選擇要推送的信息'); return false; } window.open('sp/PushToSp.php?tid=<?=$tid?>&id='+id,'PushToSp','width=360,height=500,scrollbars=yes,left=300,top=150,resizable=yes'); } </script> </head> <body> <table width="100%" border="0" align="center" cellpadding="3" cellspacing="1"> <form name="AddNewsForm" method="get"> <tr> <td width="37%">位置: <?=$url?> </td> <td width="63%"><div align="right"> <input type="button" name="Submit4" value="刷新首頁" onclick="self.location.href='ecmschtml.php?enews=ReIndex'"> <input type="button" name="Submit4" value="刷新所有信息JS" onclick="window.open('ecmschtml.php?enews=ReAllNewsJs&from=<?=$phpmyself?>','','');"> <span id="showaddclassnav"></span> <input type="button" name="Submit" value="增加信息" onclick="if(document.AddNewsForm.addclassid.value!=0){window.open('AddNews.php?enews=AddNews&classid='+document.AddNewsForm.addclassid.value,'','');}else{alert('請選擇要增加信息的欄目');document.AddNewsForm.addclassid.focus();}"> </div></td> </tr> </form> </table> <table width="100%" border="0" align="center" cellpadding="3" cellspacing="1" class="tableborder"> <form name="SearchForm" method="GET" action="ListAllInfo.php"> <tr> <td width="100%"> <div align="right"> 搜索: <select name="showspecial" id="showspecial"> <option value="0"<?=$showspecial==0?' selected':''?>>不限屬性</option> <option value="1"<?=$showspecial==1?' selected':''?>>置頂</option> <option value="2"<?=$showspecial==2?' selected':''?>>推薦</option> <option value="3"<?=$showspecial==3?' selected':''?>>頭條</option> <option value="4"<?=$showspecial==4?' selected':''?>>未審核</option> <option value="6"<?=$showspecial==6?' selected':''?>>已審核</option> <option value="7"<?=$showspecial==7?' selected':''?>>投稿</option> <option value="5"<?=$showspecial==5?' selected':''?>>簽發</option> </select> <input name="keyboard" type="text" id="keyboard" value="<?=$keyboard?>"> <select name="show"> <option value="0"<?=$show==0?' selected':''?>>不限字段</option> <option value="1"<?=$show==1?' selected':''?>>標題</option> <option value="2"<?=$show==2?' selected':''?>>發佈者</option> <option value="3"<?=$show==3?' selected':''?>>ID</option> </select> <?=$stts?> <select name="ztid" id="ztid"> <option value="0">所有專題</option> <?=$ztclass?> </select> <span id="searchclassnav"></span> <select name="myorder" id="myorder"> <option value="1"<?=$myorder==1?' selected':''?>>按信息ID</option> <option value="2"<?=$myorder==2?' selected':''?>>按發佈時間</option> <option value="3"<?=$myorder==3?' selected':''?>>按點擊率</option> <option value="4"<?=$myorder==4?' selected':''?>>按下載數</option> <option value="5"<?=$myorder==5?' selected':''?>>按評論數</option> </select> <select name="orderby" id="orderby"> <option value="0"<?=$orderby==0?' selected':''?>>降序排序</option> <option value="1"<?=$orderby==1?' selected':''?>>升序排序</option> </select> <input type="submit" name="Submit2" value="搜索"> <input name="tbname" type="hidden" value="<?=$tbname?>"> <input name="sear" type="hidden" value="1"> </div></td> </tr> </form> </table> <form name="listform" method="post" action="ecmsinfo.php" onsubmit="return confirm('確認要執行此操作?');"> <input type=hidden name=enews value=DelNews_all> <input name=mid type=hidden id="mid" value=<?=$mid?>> <table width="100%" border="0" align="center" cellpadding="3" cellspacing="1" class="tableborder"> <tr class="header"> <td height="25" colspan="7"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="46%"><select name="tbname" onchange="if(this.options[this.selectedIndex].value!=0){self.location.href='ListAllInfo.php?<?=str_replace('&tbname=','&',$search1)?>&tbname='+this.options[this.selectedIndex].value;}"> <?=$changetbs?> </select> </td> <td width="54%"> <div align="right"><font color="#ffffff">[<a href="ListAllInfo.php?tbname=<?=$tbname?>&showretitle=1&srt=1" title="查詢重複標題,並保留一條信息">查詢重複標題A</a>] [<a href="ListAllInfo.php?tbname=<?=$tbname?>&showretitle=1&srt=0" title="查詢重複標題的信息(不保留信息)">查詢重複標題B</a>] [<a href="ReHtml/ChangeData.php" target=_blank>更新數據</a>] [<a href="../../" target=_blank>預覽首頁</a>]</font></div></td> </tr> </table></td> </tr> <tr> <td width="3%"><div align="center"></div></td> <td width="7%" height="25"><div align="center">ID</div></td> <td width="38%" height="25"><div align="center">標題</div></td> <td width="15%" height="25"><div align="center">發佈者</div></td> <td width="8%" height="25"><div align="center">點擊</div></td> <td width="17%" height="25"> <div align="center">發佈時間</div></td> <td width="12%" height="25"> <div align="center">操作</div></td> </tr> <?php while($r=$empire->fetch($sql)) { //狀態 $st=''; if($r[istop])//置頂 { $st.="<font color=red>[頂".$r[istop]."]</font>"; } if($r[isgood])//推薦 { $st.="<font color=red>[推]</font>"; } if($r[firsttitle])//頭條 { $st.="<font color=red>[頭]</font>"; } $oldtitle=$r[title]; $r[title]=stripSlashes(sub($r[title],0,36,false)); //時間 $truetime=date("Y-m-d H:i:s",$r[truetime]); $lastdotime=date("Y-m-d H:i:s",$r[lastdotime]); //審核 if(empty($r[checked])) { $checked=" title='未審核' style='background:#99C4E3'"; $titleurl="ShowInfo.php?classid=$r[classid]&id=$r[id]"; } else { $checked=""; $titleurl=sys_ReturnBqTitleLink($r); } //會員投稿 if($r[ismember]) { $r[username]="<a href='member/AddMember.php?enews=EditMember&userid=".$r[userid]."' target='_blank'><font color=red>".$r[username]."</font></a>"; } //取得類別名 $do=$r[classid]; $dob=$class_r[$r[classid]][bclassid]; //簽發 $qf=""; if($r[isqf]) { $qfr=$empire->fetch1("select checktno,tstatus from {$dbtbpre}enewswfinfo where id='$r[id]' and classid='$r[classid]' limit 1"); if($qfr[checktno]=='100') { $qf="(<font color='red'>已通過</font>)"; } elseif($qfr[checktno]=='101') { $qf="(<font color='red'>返工</font>)"; } elseif($qfr[checktno]=='102') { $qf="(<font color='red'>已否決</font>)"; } else { $qf="(<font color='red'>$qfr[tstatus]</font>)"; } $qf="<a href='#ecms' onclick=\"window.open('workflow/DoWfInfo.php?classid=$r[classid]&id=$r[id]','','width=600,height=520,scrollbars=yes');\">".$qf."</a>"; } //標題圖片 $showtitlepic=""; if($r[titlepic]) { $showtitlepic="<a href='".$r[titlepic]."' title='預覽標題圖片' target=_blank><img src='../data/images/showimg.gif' border=0></a>"; } //未生成 $myid="<a href='ecmschtml.php?enews=ReSingleInfo&classid=$r[classid]&id[]=".$r[id]."'>".$r['id']."</a>"; if(empty($r[havehtml])) { $myid="<a href='ecmschtml.php?enews=ReSingleInfo&classid=$r[classid]&id[]=".$r[id]."' title='未生成'><b>".$r[id]."</b></a>"; } ?> <tr bgcolor="#FFFFFF" onmouseout="this.style.backgroundColor='#ffffff'" onmouseover="this.style.backgroundColor='#DBEAF5'"> <td><div align="center"> <input name="id[]" type="checkbox" id="id[]" value="<?=$r[id]?>"<?=$checked?>> </div></td> <td height="25"> <div align="center"> <?=$myid?> </div></td> <td height="25"> <div align="left"> <?=$st?> <?=$showtitlepic?> <a href='<?=$titleurl?>' target=_blank title="<?=$oldtitle?>"><?=$r[title]?></a> <?=$qf?> <br> <font color="#574D5C">欄目:<a href='ListNews.php?bclassid=<?=$class_r[$r[classid]][bclassid]?>&classid=<?=$r[classid]?>'> <font color="#574D5C"><?=$class_r[$dob][classname]?></font> </a> > <a href='ListNews.php?bclassid=<?=$class_r[$r[classid]][bclassid]?>&classid=<?=$r[classid]?>'> <font color="#574D5C"><?=$class_r[$r[classid]][classname]?></font> </a></font></div></td> <td height="25"> <div align="center"> <?=$r[username]?> </div></td> <td height="25"> <div align="center"><a title="下載次數:<?=$r[totaldown]?>"> <?=$r[onclick]?> </a></div></td> <td height="25"> <div align="center"> <a href="AddNews.php?enews=EditNews&id=<?=$r[id]?>&classid=<?=$r[classid]?>&bclassid=<?=$class_r[$r[classid]][bclassid]?>" title="<? echo"增加時間:".$truetime."\r\n最後修改:".$lastdotime;?>" target="_blank"><?=date("Y-m-d H:i:s",$r[newstime])?></a> </div></td> <td height="25"> <div align="center">[<a href="pl/ListPl.php?id=<?=$r[id]?>&classid=<?=$r[classid]?>&bclassid=<?=$class_r[$r[classid]][bclassid]?>" target="_blank">評論</a>] <a href="AddNews.php?enews=EditNews&id=<?=$r[id]?>&classid=<?=$r[classid]?>&bclassid=<?=$class_r[$r[classid]][bclassid]?>" target="_blank"><img src=../data/images/EditNews.png alt='修改' title='修改信息' border=0></a> <a href="ecmsinfo.php?enews=DelNews&id=<?=$r[id]?>&classid=<?=$r[classid]?>&bclassid=<?=$class_r[$r[classid]][bclassid]?>" onclick="return confirm('確認要刪除?');"><img src=../data/images/DelNews.png alt='刪除' title='刪除信息' border=0></a> </div></td> </tr> <? } ?> <input type=hidden name=classid value=<?=$do?>> <input type=hidden name=bclassid value=<?=$dob?>> <tr bgcolor="#FFFFFF"> <td height="25"> <div align="center"> <input type=checkbox name=chkall value=on onclick=CheckAll(this.form)> </div></td> <td height="25" colspan="6"><div align="right"> <input type="submit" name="Submit3" value="刪除" onclick="document.listform.enews.value='DelNews_all';document.listform.action='ecmsinfo.php';"> <input type="submit" name="Submit8" value="審核" onClick="document.listform.enews.value='CheckNews_all';document.listform.action='ecmsinfo.php';"> <input type="submit" name="Submit9" value="取消審核" onClick="document.listform.enews.value='NoCheckNews_all';document.listform.action='ecmsinfo.php';"> <input type="submit" name="Submit8" value="刷新" onClick="document.listform.enews.value='ReSingleInfo';document.listform.action='ecmschtml.php';"> <input type="button" name="Submit112" value="推送" onClick="PushInfoToSp(this.form);"> <select name="istop" id="select2"> <option value="0">不置頂</option> <option value="1">1級置頂</option> <option value="2">2級置頂</option> <option value="3">3級置頂</option> <option value="4">4級置頂</option> <option value="5">5級置頂</option> <option value="6">6級置頂</option> <option value="7">7級置頂</option> <option value="8">8級置頂</option> </select> <input type="submit" name="Submit7" value="置頂" onclick="document.listform.enews.value='TopNews_all';document.listform.action='ecmsinfo.php';"> <span id="moveclassnav"></span> <input type="submit" name="Submit5" value="移動" onclick="document.listform.enews.value='MoveNews_all';document.listform.action='ecmsinfo.php';"> <input type="submit" name="Submit6" value="複製" onclick="document.listform.enews.value='CopyNews_all';document.listform.action='ecmsinfo.php';"> </div></td> </tr> <tr bgcolor="#FFFFFF"> <td height="25" colspan="7"> <?=$returnpage?> </td> </tr> <tr bgcolor="#FFFFFF"> <td height="25" colspan="7"> <font color="#666666">備註:多選框為藍色代表未審核信息,會員投稿作者為紅色,簽發信息標題後有說明.</font></td> </tr> </table> </form> <IFRAME frameBorder="0" id="showclassnav" name="showclassnav" scrolling="no" src="ShowClassNav.php?ecms=2&classid=<?=$classid?>" style="HEIGHT:0;VISIBILITY:inherit;WIDTH:0;Z-INDEX:1"></IFRAME> </body> </html>